﻿
IF (EXISTS(SELECT id from sysobjects where id=object_id('usp_InsertVoter')))
	DROP PROCEDURE [dbo].[usp_InsertVoter]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




create procedure usp_InsertVoter
@WardId  as nvarchar(50),
@VoterId  as nvarchar(50),
@Name  as nvarchar(50),
@FatherName  as nvarchar(50),
@DateOfBirth  as datetime,
@Address  as nvarchar(50),
@EmailId  as nvarchar(50),
@DistrictId as nvarchar(50),
@PanchayatId as nvarchar(50),
@Password as nvarchar(50)

as
insert into TBLVOTER (DistrictId, PanchayatId, WardId,VOTERID,NAME,FATHERNAME,DateOfBirth,
Address,EmailId,Password,IsAdmin)
values 
(@DistrictId,@PanchayatId,@WardId,@VoterId,@Name,@FatherName,@DateOfBirth,@Address,@EmailId,@Password,0)

